In this article, we look at using SQLAlchemy to work with databases and database objects versus using SQL Server Management Studio (SSMS) or other native SQL tools.
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code. Because of how relational databases implement NULLs, it definitely can make some processes more complex than expected by may programmers (inexperienced and experienced alike!) Three Valued Logic Missing or UNKNOWN values …
The post SQL Logic appeared first on Simple Talk.
On the blog Fabric Notebook and Deployment Pipelines I explained a technique to keep notebooks configuration values in JSON files on lakehouses, a good solution from many different points of views. What if we need to provide maintenance to the JSON configuration file using notebooks? The first problem is the fact the typical statement to …
The post Creating a Single JSON File for Configuration using Notebooks appeared first on Simple Talk.
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us, so we are offered …
The post Pagination and ordering by large values appeared first on Simple Talk.
This article includes a PowerShell script that you can run to get a list of your Azure SQL Databases and data such as Server Name, Subscription, Resource Group, Location, Administrator Login, Entra Admin, and CreateDate.
The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.
Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and we can only see or change its value through XMLA. For example, we can use Tabular Editor for this. We can disable this property in the fields where it will not be needed (and in …
The post Model Optimization: Available In MDX Property appeared first on Simple Talk.
In this post, we will discuss, what is restore point in an oracle, how to check restore point in oracle What is a Restore Point in Oracle? Guaranteed restore points Normal Restore Points how to check the restore point in Oracle You can check the restore point in the Oracle database using the below query …
how to check the restore point in Oracle Read More »
The post how to check the restore point in Oracle appeared first on Techgoeasy.
This article will show how to create a SQL Server DDL trigger to capture any DDL commands issued like Create, Alter, Drop, and then send an email notification.
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies. The first source of redundancy back in the dark ages, when I was just beginning the program, was a product called …
The post Department of Redundancy Department appeared first on Simple Talk.
Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential. A container is a compact and self-contained package comprising essential components like code, runtime, libraries, and system tools necessary for running an application. Container …
The post Kubernetes For Complete Beginners appeared first on Simple Talk.
In this article, we will dynamically copy data from an on-premises SQL Server to Azure SQL Database using Azure Data Factory and Microsoft Integration Runtime.
Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the previous version they are considered a new feature. The main difference is the possibility to set a target for the result of each query in the dataflow. In this way, it can be used as …
The post 5 Secrets about Dataflows Gen 2 appeared first on Simple Talk.
The need to merge tables when developing Power BI solutions is a fundamental task. In Power BI, DAX offers a powerful function, NATURALINNERJOIN, to streamline this task, making the process of combining data using DAX easier.
In this article, we look at how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.